package com.oracle.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.oracle.pojo.Publicity;
import org.apache.ibatis.annotations.Select;

public interface PublicityMapper extends BaseMapper<Publicity> {
    @Select("SELECT * FROM publicity WHERE tip_State = #{state} ORDER BY tip_Time DESC LIMIT 1")
    Publicity findEarliestByStatus(Integer state);
}
